PREVIEW / etf_30min / 2008-04-09

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-04-09.parquet
  size:    153 KB
  rows:    5,551

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-04-09 04:00:00	SPY	ETF	136.32	136.32	136.32	136.32	200.0
2008-04-09 05:30:00	SPY	ETF	136.18	136.18	136.17	136.17	1100.0
2008-04-09 06:00:00	SPY	ETF	136.17	136.4	136.12	136.4	25600.0
2008-04-09 06:30:00	SPY	ETF	136.45	136.62	136.4	136.54	29900.0
2008-04-09 07:00:00	SPY	ETF	136.74	136.97	136.74	136.79	256900.0
2008-04-09 07:30:00	SPY	ETF	136.78	136.8	136.45	136.62	580500.0
2008-04-09 08:00:00	SPY	ETF	136.62	136.94	136.2	136.54	1878200.0
2008-04-09 08:30:00	SPY	ETF	136.54	136.69	136.45	136.57	808786.0
2008-04-09 09:00:00	SPY	ETF	136.56	136.61	136.44	136.61	739700.0
2008-04-09 09:30:00	SPY	ETF	136.61	136.8	136.06	136.18	21110635.0
2008-04-09 10:00:00	SPY	ETF	136.18	136.28	135.9	136.13	14379229.0
2008-04-09 10:30:00	SPY	ETF	136.13	136.21	135.83	136.15	14912461.0
2008-04-09 11:00:00	SPY	ETF	136.15	136.31	135.62	135.73	16787993.0
2008-04-09 11:30:00	SPY	ETF	135.74	135.79	135.26	135.319	18663920.0
2008-04-09 12:00:00	SPY	ETF	135.32	135.52	135.23	135.5	8499637.0
2008-04-09 12:30:00	SPY	ETF	135.49	135.58	135.14	135.19	8395448.0
2008-04-09 13:00:00	SPY	ETF	135.18	135.48	135.01	135.37	12874008.0
2008-04-09 13:30:00	SPY	ETF	135.36	135.59	135.28	135.59	7227112.0
2008-04-09 14:00:00	SPY	ETF	135.59	135.7	135.1	135.24	12729224.0
2008-04-09 14:30:00	SPY	ETF	135.24	135.46	134.97	135.06	10439028.0
2008-04-09 15:00:00	SPY	ETF	135.06	135.33	134.89	135.16	13047919.0
2008-04-09 15:30:00	SPY	ETF	135.16	135.6	135.12	135.39	16521902.0
2008-04-09 16:00:00	SPY	ETF	135.41	136.4668	135.3277	135.68	4939600.0
2008-04-09 16:30:00	SPY	ETF	135.7	136.47	135.67	135.83	6621900.0
2008-04-09 17:00:00	SPY	ETF	135.73	135.77	135.67	135.76	58500.0
2008-04-09 17:30:00	SPY	ETF	135.74	135.8	135.68	135.7	42300.0
2008-04-09 18:00:00	SPY	ETF	135.71	135.77	135.66	135.66	45900.0
2008-04-09 18:30:00	SPY	ETF	135.69	135.69	135.63	135.63	17300.0
2008-04-09 19:00:00	SPY	ETF	135.72	135.72	135.62	135.62	10500.0
2008-04-09 19:30:00	SPY	ETF	135.62	135.75	135.6	135.73	35100.0
2008-04-09 05:00:00	QQQ	ETF	45.38	45.38	45.34	45.34	1400.0
2008-04-09 05:30:00	QQQ	ETF	45.36	45.36	45.36	45.36	2900.0
2008-04-09 06:00:00	QQQ	ETF	45.31	45.35	45.31	45.33	20400.0
2008-04-09 06:30:00	QQQ	ETF	45.39	45.44	45.39	45.44	2600.0
2008-04-09 07:00:00	QQQ	ETF	45.51	45.63	45.51	45.6	121767.0
2008-04-09 07:30:00	QQQ	ETF	45.58	45.58	45.49	45.5	274275.0
2008-04-09 08:00:00	QQQ	ETF	45.5	45.53	45.45	45.47	697777.0
2008-04-09 08:30:00	QQQ	ETF	45.46	45.54	45.46	45.52	432590.0
2008-04-09 09:00:00	QQQ	ETF	45.52	45.53	45.47	45.47	276069.0
2008-04-09 09:30:00	QQQ	ETF	45.47	45.49	45.0595	45.14	13471971.0
2008-04-09 10:00:00	QQQ	ETF	45.15	45.28	45.03	45.17	10911688.0
2008-04-09 10:30:00	QQQ	ETF	45.18	45.19	44.98	45.13	10694524.0
2008-04-09 11:00:00	QQQ	ETF	45.13	45.17	44.94	44.99	8486739.0
2008-04-09 11:30:00	QQQ	ETF	44.99	45.0	44.74	44.79	10504370.0
2008-04-09 12:00:00	QQQ	ETF	44.79	44.9	44.77	44.88	6305081.0
2008-04-09 12:30:00	QQQ	ETF	44.88	44.9	44.75	44.7619	4137141.0
2008-04-09 13:00:00	QQQ	ETF	44.76	44.94	44.75	44.88	7008417.0
2008-04-09 13:30:00	QQQ	ETF	44.88	44.96	44.85	44.94	5300750.0
2008-04-09 14:00:00	QQQ	ETF	44.95	45.0	44.7	44.77	7293206.0
2008-04-09 14:30:00	QQQ	ETF	44.76	44.82	44.63	44.68	7881894.0

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

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