PREVIEW / etf_30min / 2009-05-11

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-05-11.parquet
  size:    218 KB
  rows:    7,338

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-05-11 04:00:00	SPY	ETF	91.89	91.96	91.83	91.83	4500.0
2009-05-11 04:30:00	SPY	ETF	91.7	91.79	91.62	91.79	3000.0
2009-05-11 05:00:00	SPY	ETF	91.9	91.9	91.76	91.76	19000.0
2009-05-11 05:30:00	SPY	ETF	91.72	91.75	91.6	91.72	3900.0
2009-05-11 06:00:00	SPY	ETF	91.63	91.97	91.63	91.95	27200.0
2009-05-11 06:30:00	SPY	ETF	91.99	92.05	91.84	92.0	25500.0
2009-05-11 07:00:00	SPY	ETF	91.97	92.04	91.84	91.87	217508.0
2009-05-11 07:30:00	SPY	ETF	91.86	92.03	91.73	91.77	543882.0
2009-05-11 08:00:00	SPY	ETF	91.78	91.9	91.51	91.62	1096599.0
2009-05-11 08:30:00	SPY	ETF	91.61	92.4009	91.58	91.65	1425909.0
2009-05-11 09:00:00	SPY	ETF	91.66	92.25	91.52	91.69	1603923.0
2009-05-11 09:30:00	SPY	ETF	91.7	91.8	91.04	91.34	28474044.0
2009-05-11 10:00:00	SPY	ETF	91.35	91.77	91.2	91.501	17746083.0
2009-05-11 10:30:00	SPY	ETF	91.51	91.99	91.39	91.82	20884628.0
2009-05-11 11:00:00	SPY	ETF	91.82	92.11	91.67	91.8	11872488.0
2009-05-11 11:30:00	SPY	ETF	91.8	91.88	91.54	91.57	13114104.0
2009-05-11 12:00:00	SPY	ETF	91.57	91.75	91.44	91.65	7468014.0
2009-05-11 12:30:00	SPY	ETF	91.65	91.74	91.43	91.44	7515261.0
2009-05-11 13:00:00	SPY	ETF	91.44	91.72	91.28	91.67	11338586.0
2009-05-11 13:30:00	SPY	ETF	91.67	91.94	91.57	91.8	12939624.0
2009-05-11 14:00:00	SPY	ETF	91.8	91.8	91.54	91.71	21647364.0
2009-05-11 14:30:00	SPY	ETF	91.71	91.93	91.57	91.7413	20722107.0
2009-05-11 15:00:00	SPY	ETF	91.74	91.8	91.32	91.461	26347440.0
2009-05-11 15:30:00	SPY	ETF	91.46	91.52	91.06	91.19	28598299.0
2009-05-11 16:00:00	SPY	ETF	91.21	91.6102	91.0845	91.3	7394332.0
2009-05-11 16:30:00	SPY	ETF	91.33	91.35	91.18	91.2	2159721.0
2009-05-11 17:00:00	SPY	ETF	91.22	93.1258	91.08	91.09	2938878.0
2009-05-11 17:30:00	SPY	ETF	91.08	91.19	91.0	91.06	141596.0
2009-05-11 18:00:00	SPY	ETF	91.06	91.09	90.81	90.88	153938.0
2009-05-11 18:30:00	SPY	ETF	90.89	90.92	90.84	90.92	29879.0
2009-05-11 19:00:00	SPY	ETF	90.89	90.92	90.85	90.88	29317.0
2009-05-11 19:30:00	SPY	ETF	90.93	91.03	90.88	90.88	54385.0
2009-05-11 04:00:00	QQQ	ETF	33.76	33.76	33.76	33.76	597.0
2009-05-11 04:30:00	QQQ	ETF	33.72	33.75	33.66	33.75	2140.0
2009-05-11 06:00:00	QQQ	ETF	33.77	33.77	33.77	33.77	200.0
2009-05-11 06:30:00	QQQ	ETF	33.75	33.8	33.73	33.8	52600.0
2009-05-11 07:00:00	QQQ	ETF	33.8	33.84	33.77	33.79	237916.0
2009-05-11 07:30:00	QQQ	ETF	33.8	33.85	33.77	33.78	162254.0
2009-05-11 08:00:00	QQQ	ETF	33.79	33.83	33.71	33.75	1097826.0
2009-05-11 08:30:00	QQQ	ETF	33.74	33.8	33.74	33.75	294053.0
2009-05-11 09:00:00	QQQ	ETF	33.75	33.85	33.71	33.78	1246668.0
2009-05-11 09:30:00	QQQ	ETF	33.78	33.95	33.68	33.9001	14649135.0
2009-05-11 10:00:00	QQQ	ETF	33.91	34.38	33.85	34.29	19813652.0
2009-05-11 10:30:00	QQQ	ETF	34.3	34.64	34.1125	34.4	23229146.0
2009-05-11 11:00:00	QQQ	ETF	34.4	34.57	34.36	34.42	7811885.0
2009-05-11 11:30:00	QQQ	ETF	34.43	34.5	34.31	34.36	7799410.0
2009-05-11 12:00:00	QQQ	ETF	34.35	34.5	34.3	34.46	5275824.0
2009-05-11 12:30:00	QQQ	ETF	34.46	34.49	34.39	34.4	3433580.0
2009-05-11 13:00:00	QQQ	ETF	34.4001	34.57	34.36	34.53	6738618.0
2009-05-11 13:30:00	QQQ	ETF	34.54	34.72	34.5	34.65	5480084.0

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

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