PREVIEW / etf_30min / 2009-04-06

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-04-06.parquet
  size:    211 KB
  rows:    7,018

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-04-06 04:00:00	SPY	ETF	84.99	85.08	84.79	84.83	1655.0
2009-04-06 04:30:00	SPY	ETF	84.83	85.0	84.83	84.93	10300.0
2009-04-06 05:00:00	SPY	ETF	84.81	84.84	84.74	84.76	3000.0
2009-04-06 05:30:00	SPY	ETF	84.93	85.0	84.71	84.71	3600.0
2009-04-06 06:00:00	SPY	ETF	84.71	84.79	84.64	84.79	4400.0
2009-04-06 06:30:00	SPY	ETF	84.81	84.81	84.69	84.69	3800.0
2009-04-06 07:00:00	SPY	ETF	84.7	84.7	84.34	84.38	205346.0
2009-04-06 07:30:00	SPY	ETF	84.38	84.38	83.96	84.0	606561.0
2009-04-06 08:00:00	SPY	ETF	84.945	85.1	83.58	83.59	2252082.0
2009-04-06 08:30:00	SPY	ETF	83.6	83.65	83.42	83.55	1098646.0
2009-04-06 09:00:00	SPY	ETF	83.54	83.55	83.18	83.33	2477336.0
2009-04-06 09:30:00	SPY	ETF	83.34	83.47	82.9	83.17	28534402.0
2009-04-06 10:00:00	SPY	ETF	83.17	84.2747	82.8	82.82	26985184.0
2009-04-06 10:30:00	SPY	ETF	82.8306	83.2536	82.75	82.97	15082512.0
2009-04-06 11:00:00	SPY	ETF	82.97	82.98	82.6	82.87	12859677.0
2009-04-06 11:30:00	SPY	ETF	82.88	82.98	82.45	82.5394	14236750.0
2009-04-06 12:00:00	SPY	ETF	82.53	82.66	82.3	82.3909	9353263.0
2009-04-06 12:30:00	SPY	ETF	82.4	82.77	82.29	82.7203	8412300.0
2009-04-06 13:00:00	SPY	ETF	82.73	82.87	82.58	82.5901	11355861.0
2009-04-06 13:30:00	SPY	ETF	82.6	82.99	82.42	82.88	12470932.0
2009-04-06 14:00:00	SPY	ETF	82.89	83.08	82.72	82.97	14194632.0
2009-04-06 14:30:00	SPY	ETF	82.97	83.22	82.6	83.0	25364808.0
2009-04-06 15:00:00	SPY	ETF	83.0	83.35	82.79	83.1	27452970.0
2009-04-06 15:30:00	SPY	ETF	83.1	83.81	82.98	83.51	39209882.0
2009-04-06 16:00:00	SPY	ETF	83.51	83.62	83.42	83.5	3796236.0
2009-04-06 16:30:00	SPY	ETF	83.5	83.75	83.1	83.6	367322.0
2009-04-06 17:00:00	SPY	ETF	83.61	83.78	83.61	83.68	247572.0
2009-04-06 17:30:00	SPY	ETF	83.68	83.73	83.65	83.7	9780.0
2009-04-06 18:00:00	SPY	ETF	83.69	83.76	83.69	83.74	22225.0
2009-04-06 18:30:00	SPY	ETF	83.73	83.73	83.6	83.6	13382.0
2009-04-06 19:00:00	SPY	ETF	83.6	83.62	83.6	83.62	2046.0
2009-04-06 19:30:00	SPY	ETF	83.63	83.65	83.44	83.65	109472.0
2009-04-06 04:00:00	QQQ	ETF	32.59	32.61	32.59	32.6	1731.0
2009-04-06 04:30:00	QQQ	ETF	32.6	32.6	32.57	32.57	2100.0
2009-04-06 05:00:00	QQQ	ETF	32.5	32.5	32.5	32.5	200.0
2009-04-06 05:30:00	QQQ	ETF	32.54	32.6	32.54	32.55	2200.0
2009-04-06 06:00:00	QQQ	ETF	32.48	32.48	32.45	32.45	100000.0
2009-04-06 06:30:00	QQQ	ETF	32.49	32.49	32.46	32.46	35500.0
2009-04-06 07:00:00	QQQ	ETF	32.44	32.45	32.32	32.33	103315.0
2009-04-06 07:30:00	QQQ	ETF	32.32	32.32	32.18	32.18	521983.0
2009-04-06 08:00:00	QQQ	ETF	32.21	32.44	31.99	32.0	1215034.0
2009-04-06 08:30:00	QQQ	ETF	32.01	32.02	31.88	31.95	1108817.0
2009-04-06 09:00:00	QQQ	ETF	31.95	32.3766	31.84	31.96	2700297.0
2009-04-06 09:30:00	QQQ	ETF	31.97	32.07	31.75	31.87	19393254.0
2009-04-06 10:00:00	QQQ	ETF	31.86	32.0	31.68	31.69	11999236.0
2009-04-06 10:30:00	QQQ	ETF	31.69	31.84	31.67	31.75	7779544.0
2009-04-06 11:00:00	QQQ	ETF	31.75	31.8	31.65	31.77	8690400.0
2009-04-06 11:30:00	QQQ	ETF	31.77	31.85	31.69	31.74	7333817.0
2009-04-06 12:00:00	QQQ	ETF	31.74	31.83	31.68	31.718	4337562.0
2009-04-06 12:30:00	QQQ	ETF	31.71	31.89	31.66	31.89	4838810.0

> showing 50 of 7,018 rows — these rows as CSV

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