PREVIEW / etf_30min / 2008-07-29

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-07-29.parquet
  size:    166 KB
  rows:    5,755

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-07-29 04:00:00	SPY	ETF	123.84	123.84	123.84	123.84	100.0
2008-07-29 05:00:00	SPY	ETF	123.92	123.92	123.92	123.92	100.0
2008-07-29 06:00:00	SPY	ETF	123.28	123.56	123.28	123.56	2000.0
2008-07-29 06:30:00	SPY	ETF	123.49	123.58	123.49	123.55	25100.0
2008-07-29 07:00:00	SPY	ETF	123.74	124.08	123.67	123.88	627648.0
2008-07-29 07:30:00	SPY	ETF	123.88	124.2	123.88	124.17	923871.0
2008-07-29 08:00:00	SPY	ETF	124.17	124.29	123.51	124.09	1181060.0
2008-07-29 08:30:00	SPY	ETF	124.09	124.15	124.02	124.05	805523.0
2008-07-29 09:00:00	SPY	ETF	124.05	124.09	123.86	123.99	1314408.0
2008-07-29 09:30:00	SPY	ETF	123.98	124.5	123.84	124.49	27288565.0
2008-07-29 10:00:00	SPY	ETF	124.49	124.97	124.43	124.77	36245378.0
2008-07-29 10:30:00	SPY	ETF	124.77	125.13	124.77	124.909	18264579.0
2008-07-29 11:00:00	SPY	ETF	124.9	125.02	124.68	124.89	11288854.0
2008-07-29 11:30:00	SPY	ETF	124.89	125.34	124.8	125.18	18086587.0
2008-07-29 12:00:00	SPY	ETF	125.19	125.4	125.13	125.34	13205005.0
2008-07-29 12:30:00	SPY	ETF	125.3722	125.41	125.04	125.34	16060929.0
2008-07-29 13:00:00	SPY	ETF	125.33	125.5	125.13	125.5	8037714.0
2008-07-29 13:30:00	SPY	ETF	125.49	125.75	125.42	125.71	12346125.0
2008-07-29 14:00:00	SPY	ETF	125.71	125.76	125.3	125.57	15047175.0
2008-07-29 14:30:00	SPY	ETF	125.57	125.67	125.06	125.42	21123773.0
2008-07-29 15:00:00	SPY	ETF	125.42	126.0	125.34	125.93	19097299.0
2008-07-29 15:30:00	SPY	ETF	125.94	126.3	125.21	126.27	25519856.0
2008-07-29 16:00:00	SPY	ETF	126.27	126.37	124.95	126.25	8604371.0
2008-07-29 16:30:00	SPY	ETF	126.24	126.28	125.2957	126.27	1599561.0
2008-07-29 17:00:00	SPY	ETF	126.24	126.32	126.21	126.3	472554.0
2008-07-29 17:30:00	SPY	ETF	126.3	126.37	126.25	126.27	116340.0
2008-07-29 18:00:00	SPY	ETF	126.3	126.38	126.3	126.36	18296.0
2008-07-29 18:30:00	SPY	ETF	126.31	126.31	126.25	126.25	9100.0
2008-07-29 19:00:00	SPY	ETF	126.26	126.27	126.26	126.27	9000.0
2008-07-29 19:30:00	SPY	ETF	126.26	126.27	126.25	126.26	53683.0
2008-07-29 05:00:00	QQQ	ETF	44.56	44.56	44.56	44.56	400.0
2008-07-29 06:00:00	QQQ	ETF	44.42	44.42	44.4	44.4	50100.0
2008-07-29 07:00:00	QQQ	ETF	44.51	44.72	44.5	44.64	46884.0
2008-07-29 07:30:00	QQQ	ETF	44.67	44.72	44.64	44.7	34236.0
2008-07-29 08:00:00	QQQ	ETF	44.7	44.72	44.63	44.66	741364.0
2008-07-29 08:30:00	QQQ	ETF	44.66	44.68	44.64	44.66	617900.0
2008-07-29 09:00:00	QQQ	ETF	44.66	44.69	44.62	44.63	256101.0
2008-07-29 09:30:00	QQQ	ETF	44.63	44.94	44.57	44.9	19145313.0
2008-07-29 10:00:00	QQQ	ETF	44.9	45.36	44.89	45.2101	24001962.0
2008-07-29 10:30:00	QQQ	ETF	45.21	45.54	45.21	45.43	12623882.0
2008-07-29 11:00:00	QQQ	ETF	45.4219	45.44	45.3	45.36	6535956.0
2008-07-29 11:30:00	QQQ	ETF	45.36	45.5	45.27	45.4	6298314.0
2008-07-29 12:00:00	QQQ	ETF	45.4	45.5	45.26	45.36	7169981.0
2008-07-29 12:30:00	QQQ	ETF	45.35	45.36	45.17	45.24	9734661.0
2008-07-29 13:00:00	QQQ	ETF	45.2399	45.38	45.17	45.37	2811212.0
2008-07-29 13:30:00	QQQ	ETF	45.37	45.43	45.29	45.3601	3960544.0
2008-07-29 14:00:00	QQQ	ETF	45.3601	45.38	45.18	45.2701	5489229.0
2008-07-29 14:30:00	QQQ	ETF	45.28	45.33	45.12	45.2399	8015212.0
2008-07-29 15:00:00	QQQ	ETF	45.24	45.42	45.185	45.3622	7777070.0
2008-07-29 15:30:00	QQQ	ETF	45.37	45.44	45.27	45.35	14337237.0

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

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