PREVIEW / etf_30min / 2008-09-03

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-09-03.parquet
  size:    168 KB
  rows:    5,953

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-09-03 04:00:00	SPY	ETF	128.28	128.28	128.28	128.28	100.0
2008-09-03 05:30:00	SPY	ETF	128.06	128.06	127.89	127.89	2100.0
2008-09-03 06:00:00	SPY	ETF	127.96	127.96	127.91	127.91	34200.0
2008-09-03 06:30:00	SPY	ETF	127.91	127.91	127.77	127.77	79100.0
2008-09-03 07:00:00	SPY	ETF	127.8	127.8	127.49	127.49	563619.0
2008-09-03 07:30:00	SPY	ETF	127.51	127.6	127.29	127.35	571436.0
2008-09-03 08:00:00	SPY	ETF	127.34	127.99	127.31	127.63	969982.0
2008-09-03 08:30:00	SPY	ETF	127.63	127.9	127.63	127.85	748186.0
2008-09-03 09:00:00	SPY	ETF	127.87	127.91	127.68	127.9	994873.0
2008-09-03 09:30:00	SPY	ETF	127.88	128.19	127.52	128.13	23297650.0
2008-09-03 10:00:00	SPY	ETF	128.13	128.41	127.7	127.99	29908037.0
2008-09-03 10:30:00	SPY	ETF	127.99	128.5	127.58	127.86	16877596.0
2008-09-03 11:00:00	SPY	ETF	127.86	128.29	127.55	127.65	18548442.0
2008-09-03 11:30:00	SPY	ETF	127.65	127.73	127.01	127.12	18527866.0
2008-09-03 12:00:00	SPY	ETF	127.13	127.29	126.93	127.22	15565998.0
2008-09-03 12:30:00	SPY	ETF	127.22	127.26	127.01	127.15	8805882.0
2008-09-03 13:00:00	SPY	ETF	127.15	127.49	126.97	127.36	12918019.0
2008-09-03 13:30:00	SPY	ETF	127.36	127.69	127.25	127.64	14429268.0
2008-09-03 14:00:00	SPY	ETF	127.63	127.83	127.03	127.24	24759026.0
2008-09-03 14:30:00	SPY	ETF	127.24	127.61	127.0	127.34	13634870.0
2008-09-03 15:00:00	SPY	ETF	127.33	127.81	127.05	127.48	18707831.0
2008-09-03 15:30:00	SPY	ETF	127.4899	128.03	127.32	127.96	26920124.0
2008-09-03 16:00:00	SPY	ETF	127.979	127.979	127.78	127.9	2865138.0
2008-09-03 16:30:00	SPY	ETF	127.92	127.98	127.8	127.94	186992.0
2008-09-03 17:00:00	SPY	ETF	127.94	128.04	127.83	128.02	257059.0
2008-09-03 17:30:00	SPY	ETF	128.04	128.04	127.96	127.97	29981.0
2008-09-03 18:00:00	SPY	ETF	128.0	128.04	127.95	127.95	16949.0
2008-09-03 18:30:00	SPY	ETF	127.99	128.05	127.98	128.05	20775.0
2008-09-03 19:00:00	SPY	ETF	128.02	128.02	128.02	128.02	2200.0
2008-09-03 19:30:00	SPY	ETF	128.02	128.04	128.01	128.04	23578.0
2008-09-03 04:00:00	QQQ	ETF	45.67	45.67	45.67	45.67	100.0
2008-09-03 06:30:00	QQQ	ETF	45.37	45.37	45.35	45.35	3000.0
2008-09-03 07:00:00	QQQ	ETF	45.31	45.31	45.23	45.24	62415.0
2008-09-03 07:30:00	QQQ	ETF	45.23	45.27	45.15	45.21	185883.0
2008-09-03 08:00:00	QQQ	ETF	45.22	45.3	45.21	45.3	581964.0
2008-09-03 08:30:00	QQQ	ETF	45.3	45.44	45.3	45.42	3014116.0
2008-09-03 09:00:00	QQQ	ETF	45.43	45.47	45.37	45.45	2568029.0
2008-09-03 09:30:00	QQQ	ETF	45.445	45.5	45.23	45.48	24304745.0
2008-09-03 10:00:00	QQQ	ETF	45.48	45.6381	45.23	45.35	18799979.0
2008-09-03 10:30:00	QQQ	ETF	45.36	45.62	45.34	45.38	7243824.0
2008-09-03 11:00:00	QQQ	ETF	45.39	45.54	45.25	45.26	6046118.0
2008-09-03 11:30:00	QQQ	ETF	45.27	45.29	44.92	44.968	11259090.0
2008-09-03 12:00:00	QQQ	ETF	44.96	44.99	44.82	44.9778	10733913.0
2008-09-03 12:30:00	QQQ	ETF	44.98	45.03	44.88	44.99	6442977.0
2008-09-03 13:00:00	QQQ	ETF	45.0	45.16	44.91	45.04	13896309.0
2008-09-03 13:30:00	QQQ	ETF	45.04	45.21	44.95	45.16	7814718.0
2008-09-03 14:00:00	QQQ	ETF	45.16	45.29	44.94	45.04	12846144.0
2008-09-03 14:30:00	QQQ	ETF	45.045	45.2	44.9	44.94	6818753.0
2008-09-03 15:00:00	QQQ	ETF	44.94	45.08	44.79	44.98	11351844.0
2008-09-03 15:30:00	QQQ	ETF	44.98	45.15	44.91	45.12	11576141.0

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

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