PREVIEW / etf_30min / 2009-01-05

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-01-05.parquet
  size:    206 KB
  rows:    6,748

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
2009-01-05 04:00:00	SPY	ETF	92.77	92.83	92.7	92.77	5100.0
2009-01-05 04:30:00	SPY	ETF	92.75	92.75	92.66	92.66	1000.0
2009-01-05 05:00:00	SPY	ETF	92.64	92.64	92.37	92.37	4770.0
2009-01-05 05:30:00	SPY	ETF	92.33	92.55	92.28	92.55	22100.0
2009-01-05 06:00:00	SPY	ETF	92.58	92.88	92.58	92.88	3300.0
2009-01-05 06:30:00	SPY	ETF	92.81	92.81	92.53	92.58	3900.0
2009-01-05 07:00:00	SPY	ETF	92.63	92.8	92.63	92.74	139323.0
2009-01-05 07:30:00	SPY	ETF	92.77	92.79	92.32	92.36	168605.0
2009-01-05 08:00:00	SPY	ETF	92.37	92.46	91.93	92.12	904393.0
2009-01-05 08:30:00	SPY	ETF	92.11	92.3	90.24	92.16	1174167.0
2009-01-05 09:00:00	SPY	ETF	92.16	92.96	92.16	92.63	1297018.0
2009-01-05 09:30:00	SPY	ETF	92.63	92.64	91.89	92.04	23462464.0
2009-01-05 10:00:00	SPY	ETF	92.04	92.79	91.98	92.76	18219799.0
2009-01-05 10:30:00	SPY	ETF	92.76	93.35	92.68	93.1	15794265.0
2009-01-05 11:00:00	SPY	ETF	93.11	94.5533	92.68	92.7575	11982114.0
2009-01-05 11:30:00	SPY	ETF	92.75	93.06	92.66	92.67	10961742.0
2009-01-05 12:00:00	SPY	ETF	92.67	93.31	92.65	93.1	10802064.0
2009-01-05 12:30:00	SPY	ETF	93.1	93.15	92.67	92.94	9479080.0
2009-01-05 13:00:00	SPY	ETF	92.94	93.27	92.88	93.08	11168459.0
2009-01-05 13:30:00	SPY	ETF	93.07	93.57	92.84	93.43	14599252.0
2009-01-05 14:00:00	SPY	ETF	93.42	93.66	92.8	92.81	16989972.0
2009-01-05 14:30:00	SPY	ETF	92.81	93.04	92.38	92.57	16427962.0
2009-01-05 15:00:00	SPY	ETF	92.57	92.9	92.11	92.24	19733702.0
2009-01-05 15:30:00	SPY	ETF	92.24	92.83	92.09	92.8	26875667.0
2009-01-05 16:00:00	SPY	ETF	92.82	93.15	92.59	92.94	17706366.0
2009-01-05 16:30:00	SPY	ETF	92.95	93.0	92.8	92.84	6321185.0
2009-01-05 17:00:00	SPY	ETF	92.81	92.9	92.79	92.9	100165.0
2009-01-05 17:30:00	SPY	ETF	92.9	92.99	92.89	92.9	147274.0
2009-01-05 18:00:00	SPY	ETF	92.91	93.05	92.88	93.02	320417.0
2009-01-05 18:30:00	SPY	ETF	92.98	92.99	92.89	92.95	34072.0
2009-01-05 19:00:00	SPY	ETF	92.96	92.96	92.75	92.75	114539.0
2009-01-05 19:30:00	SPY	ETF	92.75	92.75	92.65	92.66	60742.0
2009-01-05 05:00:00	QQQ	ETF	30.72	30.72	30.72	30.72	100.0
2009-01-05 05:30:00	QQQ	ETF	30.7	30.71	30.7	30.71	400.0
2009-01-05 06:00:00	QQQ	ETF	30.83	30.85	30.79	30.85	14560.0
2009-01-05 07:00:00	QQQ	ETF	30.83	30.83	30.78	30.8	4400.0
2009-01-05 07:30:00	QQQ	ETF	30.85	30.86	30.72	30.72	56250.0
2009-01-05 08:00:00	QQQ	ETF	30.72	30.89	30.4	30.59	435551.0
2009-01-05 08:30:00	QQQ	ETF	30.6	30.73	30.57	30.68	818972.0
2009-01-05 09:00:00	QQQ	ETF	30.68	30.83	30.68	30.83	541431.0
2009-01-05 09:30:00	QQQ	ETF	30.83	30.93	30.59	30.62	12444485.0
2009-01-05 10:00:00	QQQ	ETF	30.63	30.93	30.59	30.9101	9041476.0
2009-01-05 10:30:00	QQQ	ETF	30.92	31.14	30.8	31.0211	8241145.0
2009-01-05 11:00:00	QQQ	ETF	31.02	31.11	30.92	30.94	4680802.0
2009-01-05 11:30:00	QQQ	ETF	30.948	31.041	30.89	30.91	3704123.0
2009-01-05 12:00:00	QQQ	ETF	30.91	31.17	30.9	31.0605	4967725.0
2009-01-05 12:30:00	QQQ	ETF	31.06	31.061	30.92	31.02	3288264.0
2009-01-05 13:00:00	QQQ	ETF	31.018	31.15	30.9901	31.0985	3781908.0
2009-01-05 13:30:00	QQQ	ETF	31.1	31.26	31.01	31.23	6989107.0
2009-01-05 14:00:00	QQQ	ETF	31.23	31.33	31.09	31.1	5670923.0

> showing 50 of 6,748 rows — these rows as CSV

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