PREVIEW / etf_30min / 2007-09-13

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-09-13.parquet
  size:    122 KB
  rows:    4,612

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-09-13 04:30:00	SPY	ETF	147.6	147.6	147.6	147.6	10000.0
2007-09-13 05:30:00	SPY	ETF	147.57	147.57	147.55	147.55	10000.0
2007-09-13 06:00:00	SPY	ETF	147.45	147.55	147.44	147.52	6700.0
2007-09-13 06:30:00	SPY	ETF	147.58	147.6	147.47	147.47	10600.0
2007-09-13 07:00:00	SPY	ETF	147.47	147.82	147.47	147.82	178400.0
2007-09-13 07:30:00	SPY	ETF	147.8	148.18	147.8	148.16	893700.0
2007-09-13 08:00:00	SPY	ETF	148.12	148.39	147.88	148.26	1614400.0
2007-09-13 08:30:00	SPY	ETF	148.24	148.65	148.24	148.48	2004900.0
2007-09-13 09:00:00	SPY	ETF	148.49	148.7	148.44	148.58	837000.0
2007-09-13 09:30:00	SPY	ETF	148.55	148.69	148.2	148.47	15697142.0
2007-09-13 10:00:00	SPY	ETF	148.47	148.78	148.31	148.67	10881100.0
2007-09-13 10:30:00	SPY	ETF	148.67	148.94	148.64	148.88	8722800.0
2007-09-13 11:00:00	SPY	ETF	148.87	149.12	148.73	149.1	8485300.0
2007-09-13 11:30:00	SPY	ETF	149.09	149.14	148.83	149.05	7137200.0
2007-09-13 12:00:00	SPY	ETF	149.05	149.15	148.81	149.01	7554200.0
2007-09-13 12:30:00	SPY	ETF	149.008	149.08	148.91	149.01	4210300.0
2007-09-13 13:00:00	SPY	ETF	149.0	149.45	149.0	149.32	14452000.0
2007-09-13 13:30:00	SPY	ETF	149.31	149.4	149.09	149.11	5315900.0
2007-09-13 14:00:00	SPY	ETF	149.1	149.23	148.83	148.87	8505700.0
2007-09-13 14:30:00	SPY	ETF	148.87	149.16	148.84	149.09	6358400.0
2007-09-13 15:00:00	SPY	ETF	149.1	149.29	148.75	148.96	11247600.0
2007-09-13 15:30:00	SPY	ETF	148.95	149.1	148.49	148.81	18128100.0
2007-09-13 16:00:00	SPY	ETF	148.78	148.91	148.72	148.84	13393500.0
2007-09-13 16:30:00	SPY	ETF	148.85	148.91	148.7	148.72	4750900.0
2007-09-13 17:00:00	SPY	ETF	148.72	149.09	148.48	148.48	543400.0
2007-09-13 17:30:00	SPY	ETF	148.48	148.51	148.37	148.51	149000.0
2007-09-13 18:00:00	SPY	ETF	148.47	148.5	148.35	148.35	48500.0
2007-09-13 18:30:00	SPY	ETF	148.37	148.4	148.32	148.36	42600.0
2007-09-13 19:00:00	SPY	ETF	148.32	148.33	148.25	148.3	70800.0
2007-09-13 19:30:00	SPY	ETF	148.29	148.32	148.23	148.24	70700.0
2007-09-13 05:30:00	QQQ	ETF	49.01	49.01	48.99	48.99	15000.0
2007-09-13 06:00:00	QQQ	ETF	48.99	49.02	48.99	49.01	50200.0
2007-09-13 07:00:00	QQQ	ETF	48.99	49.04	48.96	49.04	58568.0
2007-09-13 07:30:00	QQQ	ETF	49.05	49.18	49.04	49.18	327687.0
2007-09-13 08:00:00	QQQ	ETF	49.17	49.26	49.14	49.16	450980.0
2007-09-13 08:30:00	QQQ	ETF	49.17	49.31	49.17	49.29	1836423.0
2007-09-13 09:00:00	QQQ	ETF	49.29	49.35	49.28	49.3	1029435.0
2007-09-13 09:30:00	QQQ	ETF	49.29	49.31	49.03	49.11	9263876.0
2007-09-13 10:00:00	QQQ	ETF	49.1101	49.17	48.94	49.1	7214903.0
2007-09-13 10:30:00	QQQ	ETF	49.1	49.2	49.07	49.18	4946599.0
2007-09-13 11:00:00	QQQ	ETF	49.17	49.28	49.11	49.27	4230288.0
2007-09-13 11:30:00	QQQ	ETF	49.27	49.278	49.17	49.25	3457655.0
2007-09-13 12:00:00	QQQ	ETF	49.26	49.26	49.15	49.2299	2748669.0
2007-09-13 12:30:00	QQQ	ETF	49.22	49.25	49.18	49.21	1890614.0
2007-09-13 13:00:00	QQQ	ETF	49.21	49.35	49.19	49.2901	4851216.0
2007-09-13 13:30:00	QQQ	ETF	49.29	49.33	49.22	49.239	2465434.0
2007-09-13 14:00:00	QQQ	ETF	49.24	49.27	49.15	49.18	3235905.0
2007-09-13 14:30:00	QQQ	ETF	49.17	49.27	49.16	49.24	1811627.0
2007-09-13 15:00:00	QQQ	ETF	49.24	49.28	49.1	49.16	7501386.0
2007-09-13 15:30:00	QQQ	ETF	49.17	49.25	49.07	49.17	9666673.0

> showing 50 of 4,612 rows — these rows as CSV

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