PREVIEW / etf_30min / 2008-01-24

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-01-24.parquet
  size:    161 KB
  rows:    5,818

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-01-24 04:00:00	SPY	ETF	133.37	133.37	133.37	133.37	200.0
2008-01-24 04:30:00	SPY	ETF	133.27	133.27	133.27	133.27	1000.0
2008-01-24 05:30:00	SPY	ETF	133.98	134.08	133.98	134.08	25000.0
2008-01-24 06:00:00	SPY	ETF	134.4	135.0	134.4	134.77	40700.0
2008-01-24 06:30:00	SPY	ETF	134.68	134.98	134.65	134.68	84500.0
2008-01-24 07:00:00	SPY	ETF	134.85	134.85	134.24	134.33	389700.0
2008-01-24 07:30:00	SPY	ETF	134.39	134.65	134.19	134.19	417500.0
2008-01-24 08:00:00	SPY	ETF	134.21	134.5663	133.75	133.87	2884400.0
2008-01-24 08:30:00	SPY	ETF	133.87	134.68	133.87	134.57	3904600.0
2008-01-24 09:00:00	SPY	ETF	134.57	134.59	134.25	134.28	4802272.0
2008-01-24 09:30:00	SPY	ETF	134.26	135.04	133.91	134.58	31759853.0
2008-01-24 10:00:00	SPY	ETF	134.56	135.26	133.31	134.08	41294264.0
2008-01-24 10:30:00	SPY	ETF	134.09	134.66	133.55	133.96	22576372.0
2008-01-24 11:00:00	SPY	ETF	133.96	134.72	133.61	134.71	15481420.0
2008-01-24 11:30:00	SPY	ETF	134.7	134.97	134.33	134.51	9641906.0
2008-01-24 12:00:00	SPY	ETF	134.49	134.73	134.02	134.147	7041450.0
2008-01-24 12:30:00	SPY	ETF	134.15	134.46	133.58	134.46	10670784.0
2008-01-24 13:00:00	SPY	ETF	134.46	134.49	133.74	133.99	9756478.0
2008-01-24 13:30:00	SPY	ETF	134.0	134.91	133.8	134.57	12161092.0
2008-01-24 14:00:00	SPY	ETF	134.57	135.28	134.37	135.1288	11107857.0
2008-01-24 14:30:00	SPY	ETF	135.13	135.46	134.0	134.36	28884232.0
2008-01-24 15:00:00	SPY	ETF	134.38	134.67	134.17	134.46	12188303.0
2008-01-24 15:30:00	SPY	ETF	134.46	135.11	134.44	135.0	20122352.0
2008-01-24 16:00:00	SPY	ETF	135.06	136.3	133.78	135.33	4104000.0
2008-01-24 16:30:00	SPY	ETF	135.3	135.75	135.1	135.75	3475800.0
2008-01-24 17:00:00	SPY	ETF	135.75	135.96	135.62	135.78	946500.0
2008-01-24 17:30:00	SPY	ETF	135.82	135.96	135.7	135.73	119800.0
2008-01-24 18:00:00	SPY	ETF	135.74	135.74	135.61	135.63	44700.0
2008-01-24 18:30:00	SPY	ETF	135.63	135.72	135.61	135.7	42100.0
2008-01-24 19:00:00	SPY	ETF	135.68	135.68	135.47	135.53	24300.0
2008-01-24 19:30:00	SPY	ETF	135.51	135.55	135.5	135.54	44700.0
2008-01-24 04:30:00	QQQ	ETF	44.15	44.15	44.15	44.15	600.0
2008-01-24 05:30:00	QQQ	ETF	44.37	44.37	44.37	44.37	1500.0
2008-01-24 06:00:00	QQQ	ETF	44.48	45.53	44.48	44.63	253900.0
2008-01-24 06:30:00	QQQ	ETF	44.6	44.62	44.54	44.58	55000.0
2008-01-24 07:00:00	QQQ	ETF	44.6	44.63	44.48	44.5	581956.0
2008-01-24 07:30:00	QQQ	ETF	44.52	44.58	44.46	44.46	213723.0
2008-01-24 08:00:00	QQQ	ETF	44.47	44.48	44.15	44.16	2897256.0
2008-01-24 08:30:00	QQQ	ETF	44.18	44.57	44.18	44.39	3073480.0
2008-01-24 09:00:00	QQQ	ETF	44.39	44.42	44.18	44.22	1341859.0
2008-01-24 09:30:00	QQQ	ETF	44.2	44.9	44.14	44.75	31279132.0
2008-01-24 10:00:00	QQQ	ETF	44.75	44.93	44.06	44.34	48813103.0
2008-01-24 10:30:00	QQQ	ETF	44.34	44.59	44.25	44.42	15875208.0
2008-01-24 11:00:00	QQQ	ETF	44.44	44.57	44.23	44.5681	12272589.0
2008-01-24 11:30:00	QQQ	ETF	44.56	44.7	44.43	44.54	10699697.0
2008-01-24 12:00:00	QQQ	ETF	44.54	44.63	44.3499	44.36	8534228.0
2008-01-24 12:30:00	QQQ	ETF	44.36	44.43	44.18	44.43	8713767.0
2008-01-24 13:00:00	QQQ	ETF	44.43	44.43	44.2	44.32	6121497.0
2008-01-24 13:30:00	QQQ	ETF	44.32	44.52	44.25	44.4	8656299.0
2008-01-24 14:00:00	QQQ	ETF	44.4001	44.69	44.35	44.65	10189174.0

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

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