PREVIEW / etf_30min / 2007-02-13

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-02-13.parquet
  size:    101 KB
  rows:    3,467

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-02-13 06:30:00	SPY	ETF	143.66	143.66	143.66	143.66	25000.0
2007-02-13 07:00:00	SPY	ETF	143.65	143.68	143.65	143.68	11700.0
2007-02-13 07:30:00	SPY	ETF	143.66	143.68	143.62	143.66	19800.0
2007-02-13 08:00:00	SPY	ETF	143.66	143.75	143.5	143.73	676250.0
2007-02-13 08:30:00	SPY	ETF	143.73	143.74	143.65	143.73	235700.0
2007-02-13 09:00:00	SPY	ETF	143.73	143.76	143.67	143.75	213925.0
2007-02-13 09:30:00	SPY	ETF	143.77	144.13	143.76	144.11	7600432.0
2007-02-13 10:00:00	SPY	ETF	144.11	144.19	144.0	144.09	10751779.0
2007-02-13 10:30:00	SPY	ETF	144.08	144.18	143.87	143.91	5101242.0
2007-02-13 11:00:00	SPY	ETF	143.92	144.08	143.9	144.05	2530968.0
2007-02-13 11:30:00	SPY	ETF	144.04	144.34	144.03	144.23	5922733.0
2007-02-13 12:00:00	SPY	ETF	144.22	144.44	144.2	144.35	3542707.0
2007-02-13 12:30:00	SPY	ETF	144.35	144.45	144.33	144.37	1547700.0
2007-02-13 13:00:00	SPY	ETF	144.37	144.48	144.35	144.37	2457327.0
2007-02-13 13:30:00	SPY	ETF	144.37	144.39	144.27	144.2985	1848288.0
2007-02-13 14:00:00	SPY	ETF	144.2901	144.4	144.2901	144.32	1946661.0
2007-02-13 14:30:00	SPY	ETF	144.31	144.34	144.17	144.33	5576972.0
2007-02-13 15:00:00	SPY	ETF	144.33	144.38	144.2	144.36	2659570.0
2007-02-13 15:30:00	SPY	ETF	144.35	144.55	144.32	144.51	6234364.0
2007-02-13 16:00:00	SPY	ETF	144.52	144.66	144.34	144.62	1173940.0
2007-02-13 16:30:00	SPY	ETF	144.62	144.66	144.59	144.66	173563.0
2007-02-13 17:00:00	SPY	ETF	144.67	144.67	144.62	144.65	16800.0
2007-02-13 17:30:00	SPY	ETF	144.65	144.65	144.65	144.65	100.0
2007-02-13 18:00:00	SPY	ETF	144.62	144.65	144.6	144.62	24920.0
2007-02-13 18:30:00	SPY	ETF	144.6	144.6	144.6	144.6	300.0
2007-02-13 19:30:00	SPY	ETF	144.62	144.65	144.62	144.65	6400.0
2007-02-13 04:00:00	QQQ	ETF	43.77	43.77	43.77	43.77	2100.0
2007-02-13 04:30:00	QQQ	ETF	43.78	43.78	43.78	43.78	2000.0
2007-02-13 07:00:00	QQQ	ETF	43.72	43.73	43.72	43.73	41000.0
2007-02-13 07:30:00	QQQ	ETF	43.75	43.75	43.73	43.73	4100.0
2007-02-13 08:00:00	QQQ	ETF	43.74	43.78	43.73	43.78	187137.0
2007-02-13 08:30:00	QQQ	ETF	43.78	43.8	43.76	43.8	320979.0
2007-02-13 09:00:00	QQQ	ETF	43.8	43.8	43.76	43.78	336093.0
2007-02-13 09:30:00	QQQ	ETF	43.79	43.98	43.78	43.97	12038100.0
2007-02-13 10:00:00	QQQ	ETF	43.98	44.0	43.88	43.89	8580500.0
2007-02-13 10:30:00	QQQ	ETF	43.89	43.93	43.73	43.76	14743800.0
2007-02-13 11:00:00	QQQ	ETF	43.76	43.85	43.76	43.82	5946600.0
2007-02-13 11:30:00	QQQ	ETF	43.82	43.9	43.79	43.81	5181700.0
2007-02-13 12:00:00	QQQ	ETF	43.81	43.91	43.8	43.85	3808400.0
2007-02-13 12:30:00	QQQ	ETF	43.85	43.92	43.83	43.86	3721300.0
2007-02-13 13:00:00	QQQ	ETF	43.86	43.93	43.82	43.82	4981800.0
2007-02-13 13:30:00	QQQ	ETF	43.82	43.85	43.77	43.79	3259100.0
2007-02-13 14:00:00	QQQ	ETF	43.79	43.84	43.78	43.8	4950400.0
2007-02-13 14:30:00	QQQ	ETF	43.8	43.81	43.71	43.77	7895800.0
2007-02-13 15:00:00	QQQ	ETF	43.77	43.8	43.7	43.78	4280900.0
2007-02-13 15:30:00	QQQ	ETF	43.79	43.87	43.78	43.85	6199700.0
2007-02-13 16:00:00	QQQ	ETF	43.86	43.95	43.84	43.91	1147194.0
2007-02-13 16:30:00	QQQ	ETF	43.93	43.99	43.86	43.98	2808718.0
2007-02-13 17:00:00	QQQ	ETF	43.98	44.0	43.94	43.96	515396.0
2007-02-13 17:30:00	QQQ	ETF	43.96	43.97	43.9	43.9	149750.0

> showing 50 of 3,467 rows — these rows as CSV

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