PREVIEW / etf_30min / 2008-03-17

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-03-17.parquet
  size:    167 KB
  rows:    5,997

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2008-03-17 04:00:00	SPY	ETF	127.06	127.27	127.0	127.1	21800.0
2008-03-17 04:30:00	SPY	ETF	126.9	126.93	126.49	126.49	3600.0
2008-03-17 05:00:00	SPY	ETF	126.51	126.8	126.4	126.8	43700.0
2008-03-17 05:30:00	SPY	ETF	126.8	127.05	126.77	127.01	59000.0
2008-03-17 06:00:00	SPY	ETF	126.96	127.17	126.78	126.79	274900.0
2008-03-17 06:30:00	SPY	ETF	126.85	126.9	126.55	126.9	633000.0
2008-03-17 07:00:00	SPY	ETF	126.92	127.41	126.9	127.0	2049300.0
2008-03-17 07:30:00	SPY	ETF	127.0	127.29	126.64	127.0	3891500.0
2008-03-17 08:00:00	SPY	ETF	126.99	127.2	125.628	126.63	11741089.0
2008-03-17 08:30:00	SPY	ETF	126.59	127.16	126.0	126.27	4444700.0
2008-03-17 09:00:00	SPY	ETF	126.27	130.5	125.9	126.34	6383241.0
2008-03-17 09:30:00	SPY	ETF	126.35	128.77	126.34	127.37	49321280.0
2008-03-17 10:00:00	SPY	ETF	127.37	129.2532	127.19	128.17	38169924.0
2008-03-17 10:30:00	SPY	ETF	128.18	129.2532	127.73	128.33	30256293.0
2008-03-17 11:00:00	SPY	ETF	128.33	128.5	127.3	127.64	22230771.0
2008-03-17 11:30:00	SPY	ETF	127.65	127.97	126.93	126.94	17877604.0
2008-03-17 12:00:00	SPY	ETF	126.93	127.14	126.4	126.56	18946806.0
2008-03-17 12:30:00	SPY	ETF	126.57	127.35	126.36	127.14	19153426.0
2008-03-17 13:00:00	SPY	ETF	127.14	127.25	126.07	126.55	15561030.0
2008-03-17 13:30:00	SPY	ETF	126.56	127.27	126.1	127.21	19757491.0
2008-03-17 14:00:00	SPY	ETF	127.21	128.05	127.07	127.14	18939818.0
2008-03-17 14:30:00	SPY	ETF	127.13	128.36	126.88	127.96	21392464.0
2008-03-17 15:00:00	SPY	ETF	127.97	129.2532	127.71	128.37	34944947.0
2008-03-17 15:30:00	SPY	ETF	128.38	129.26	127.9	127.9	47163381.0
2008-03-17 16:00:00	SPY	ETF	127.83	128.65	127.8	128.56	6361400.0
2008-03-17 16:30:00	SPY	ETF	128.51	128.52	128.25	128.27	7154400.0
2008-03-17 17:00:00	SPY	ETF	128.26	128.75	128.22	128.69	2531400.0
2008-03-17 17:30:00	SPY	ETF	128.68	128.68	128.6	128.6	9400.0
2008-03-17 18:00:00	SPY	ETF	128.61	128.7	128.58	128.7	210200.0
2008-03-17 18:30:00	SPY	ETF	128.7	128.87	128.67	128.85	19200.0
2008-03-17 19:00:00	SPY	ETF	128.82	128.85	128.69	128.74	76700.0
2008-03-17 19:30:00	SPY	ETF	128.73	128.73	128.58	128.58	21400.0
2008-03-17 04:00:00	QQQ	ETF	41.44	41.44	41.44	41.44	1171.0
2008-03-17 04:30:00	QQQ	ETF	41.35	41.35	41.27	41.27	700.0
2008-03-17 05:00:00	QQQ	ETF	41.25	41.25	41.25	41.25	499.0
2008-03-17 06:00:00	QQQ	ETF	41.47	41.5	41.47	41.5	300.0
2008-03-17 06:30:00	QQQ	ETF	41.37	41.48	41.35	41.46	85638.0
2008-03-17 07:00:00	QQQ	ETF	41.44	41.59	41.37	41.38	545754.0
2008-03-17 07:30:00	QQQ	ETF	41.38	41.47	41.25	41.38	948765.0
2008-03-17 08:00:00	QQQ	ETF	41.36	42.27	40.81	41.33	3059291.0
2008-03-17 08:30:00	QQQ	ETF	41.32	41.33	41.1	41.19	1809772.0
2008-03-17 09:00:00	QQQ	ETF	41.19	41.34	41.15	41.26	3105706.0
2008-03-17 09:30:00	QQQ	ETF	41.26	41.85	41.26	41.6	26746130.0
2008-03-17 10:00:00	QQQ	ETF	41.6	41.89	41.51	41.79	16317518.0
2008-03-17 10:30:00	QQQ	ETF	41.79	41.99	41.63	41.75	11019211.0
2008-03-17 11:00:00	QQQ	ETF	41.75	41.88	41.52	41.61	10985336.0
2008-03-17 11:30:00	QQQ	ETF	41.62	41.7	41.37	41.38	9604914.0
2008-03-17 12:00:00	QQQ	ETF	41.37	41.46	41.2	41.25	12202645.0
2008-03-17 12:30:00	QQQ	ETF	41.25	41.46	41.2	41.36	7769042.0
2008-03-17 13:00:00	QQQ	ETF	41.37	41.39	41.06	41.12	10487289.0

> showing 50 of 5,997 rows — these rows as CSV

> unlock the full archive -- $79 one-time