PREVIEW / etf_30min / 2007-10-15

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-10-15.parquet
  size:    135 KB
  rows:    5,001

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
2007-10-15 05:30:00	SPY	ETF	156.45	156.45	156.42	156.42	30000.0
2007-10-15 06:00:00	SPY	ETF	156.28	156.28	156.28	156.28	4000.0
2007-10-15 06:30:00	SPY	ETF	156.24	156.27	156.23	156.23	78700.0
2007-10-15 07:00:00	SPY	ETF	156.22	156.25	156.15	156.21	183400.0
2007-10-15 07:30:00	SPY	ETF	156.2	156.26	156.03	156.15	349700.0
2007-10-15 08:00:00	SPY	ETF	156.17	156.34	156.12	156.15	245900.0
2007-10-15 08:30:00	SPY	ETF	156.27	156.46	156.27	156.39	574900.0
2007-10-15 09:00:00	SPY	ETF	156.38	156.38	156.2	156.28	506190.0
2007-10-15 09:30:00	SPY	ETF	156.27	156.36	155.73	155.78	14404800.0
2007-10-15 10:00:00	SPY	ETF	155.78	155.88	155.64	155.69	11794100.0
2007-10-15 10:30:00	SPY	ETF	155.7	155.8	155.23	155.27	12056500.0
2007-10-15 11:00:00	SPY	ETF	155.27	155.28	154.6	154.82	17449600.0
2007-10-15 11:30:00	SPY	ETF	154.81	155.01	154.63	154.99	7663500.0
2007-10-15 12:00:00	SPY	ETF	154.99	155.11	154.79	154.8494	6566300.0
2007-10-15 12:30:00	SPY	ETF	154.85	154.95	154.47	154.59	9836700.0
2007-10-15 13:00:00	SPY	ETF	154.59	154.64	154.22	154.61	13681050.0
2007-10-15 13:30:00	SPY	ETF	154.6095	154.68	154.36	154.57	4474600.0
2007-10-15 14:00:00	SPY	ETF	154.57	154.58	154.14	154.47	9797000.0
2007-10-15 14:30:00	SPY	ETF	154.47	154.63	154.32	154.45	8122450.0
2007-10-15 15:00:00	SPY	ETF	154.44	154.8	153.94	154.2	12029830.0
2007-10-15 15:30:00	SPY	ETF	154.2	154.9	154.1	154.83	19164300.0
2007-10-15 16:00:00	SPY	ETF	154.83	156.07	154.52	155.0	3526300.0
2007-10-15 16:30:00	SPY	ETF	154.99	155.02	154.94	155.02	183600.0
2007-10-15 17:00:00	SPY	ETF	155.01	155.05	154.95	155.01	1529200.0
2007-10-15 17:30:00	SPY	ETF	155.0	155.05	154.98	155.0	15000.0
2007-10-15 18:00:00	SPY	ETF	154.97	155.04	154.97	154.99	27100.0
2007-10-15 18:30:00	SPY	ETF	155.01	155.01	154.87	154.91	77900.0
2007-10-15 19:00:00	SPY	ETF	154.87	154.87	154.79	154.85	17200.0
2007-10-15 19:30:00	SPY	ETF	154.82	154.88	154.79	154.79	20800.0
2007-10-15 05:00:00	QQQ	ETF	53.63	53.63	53.63	53.63	100.0
2007-10-15 05:30:00	QQQ	ETF	53.64	53.64	53.64	53.64	2000.0
2007-10-15 06:30:00	QQQ	ETF	53.59	53.59	53.56	53.56	800.0
2007-10-15 07:00:00	QQQ	ETF	53.59	53.59	53.56	53.56	4640.0
2007-10-15 07:30:00	QQQ	ETF	53.58	53.59	53.49	53.56	325410.0
2007-10-15 08:00:00	QQQ	ETF	53.56	53.63	53.53	53.61	444613.0
2007-10-15 08:30:00	QQQ	ETF	53.63	53.69	53.61	53.63	529840.0
2007-10-15 09:00:00	QQQ	ETF	53.63	53.63	53.57	53.61	514935.0
2007-10-15 09:30:00	QQQ	ETF	53.61	53.71	53.42	53.49	12921104.0
2007-10-15 10:00:00	QQQ	ETF	53.49	53.64	53.45	53.54	7512402.0
2007-10-15 10:30:00	QQQ	ETF	53.54	53.57	53.33	53.35	10065584.0
2007-10-15 11:00:00	QQQ	ETF	53.347	53.36	53.01	53.0901	13978949.0
2007-10-15 11:30:00	QQQ	ETF	53.1	53.2	53.05	53.16	5316867.0
2007-10-15 12:00:00	QQQ	ETF	53.16	53.2	53.08	53.11	5207136.0
2007-10-15 12:30:00	QQQ	ETF	53.1	53.145	52.87	52.97	7428292.0
2007-10-15 13:00:00	QQQ	ETF	52.97	53.05	52.8	53.05	7025933.0
2007-10-15 13:30:00	QQQ	ETF	53.0486	53.08	52.95	53.05	5772001.0
2007-10-15 14:00:00	QQQ	ETF	53.04	53.05	52.78	52.98	8468053.0
2007-10-15 14:30:00	QQQ	ETF	52.98	53.03	52.89	52.95	4463210.0
2007-10-15 15:00:00	QQQ	ETF	52.94	53.04	52.7	52.77	11216671.0
2007-10-15 15:30:00	QQQ	ETF	52.78	53.11	52.75	53.11	15851234.0

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

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