PREVIEW / etf_30min / 2009-04-28

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-04-28.parquet
  size:    213 KB
  rows:    7,126

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-28 04:00:00	SPY	ETF	84.77	84.77	84.58	84.69	6000.0
2009-04-28 04:30:00	SPY	ETF	84.79	84.82	84.79	84.82	1030.0
2009-04-28 05:00:00	SPY	ETF	84.8	84.8	84.8	84.8	1600.0
2009-04-28 05:30:00	SPY	ETF	84.72	84.72	84.65	84.67	3600.0
2009-04-28 06:00:00	SPY	ETF	84.63	84.71	84.61	84.71	20099.0
2009-04-28 06:30:00	SPY	ETF	84.58	84.75	84.51	84.71	110422.0
2009-04-28 07:00:00	SPY	ETF	84.7	84.81	84.6	84.6	647477.0
2009-04-28 07:30:00	SPY	ETF	84.6	84.76	84.58	84.75	821493.0
2009-04-28 08:00:00	SPY	ETF	84.62	85.84	84.6	84.68	1347887.0
2009-04-28 08:30:00	SPY	ETF	84.67	85.1	84.65	84.98	2401290.0
2009-04-28 09:00:00	SPY	ETF	84.99	85.01	84.18	84.98	2930604.0
2009-04-28 09:30:00	SPY	ETF	84.97	85.54	84.76	85.48	29443423.0
2009-04-28 10:00:00	SPY	ETF	85.49	86.05	85.3586	86.02	29078086.0
2009-04-28 10:30:00	SPY	ETF	86.01	86.31	85.86	86.0074	19101535.0
2009-04-28 11:00:00	SPY	ETF	86.01	86.11	85.77	85.7894	14022299.0
2009-04-28 11:30:00	SPY	ETF	85.79	85.93	85.59	85.76	11701093.0
2009-04-28 12:00:00	SPY	ETF	85.76	86.18	85.76	86.07	13536930.0
2009-04-28 12:30:00	SPY	ETF	86.06	86.17	85.98	86.09	7330043.0
2009-04-28 13:00:00	SPY	ETF	86.08	86.25	85.72	85.86	13342197.0
2009-04-28 13:30:00	SPY	ETF	85.86	86.22	85.81	85.89	12992152.0
2009-04-28 14:00:00	SPY	ETF	85.89	86.4	85.88	86.32	16191782.0
2009-04-28 14:30:00	SPY	ETF	86.33	86.59	86.1617	86.24	13671656.0
2009-04-28 15:00:00	SPY	ETF	86.24	86.45	85.87	85.8801	17058737.0
2009-04-28 15:30:00	SPY	ETF	85.88	85.92	85.53	85.59	30707100.0
2009-04-28 16:00:00	SPY	ETF	85.59	86.0	84.94	85.59	4963688.0
2009-04-28 16:30:00	SPY	ETF	85.59	85.8625	85.41	85.43	2294041.0
2009-04-28 17:00:00	SPY	ETF	85.43	85.8625	85.39	85.47	2712132.0
2009-04-28 17:30:00	SPY	ETF	85.48	85.52	85.45	85.5	66319.0
2009-04-28 18:00:00	SPY	ETF	85.5	85.5	85.42	85.45	97218.0
2009-04-28 18:30:00	SPY	ETF	85.45	85.51	85.45	85.5	33586.0
2009-04-28 19:00:00	SPY	ETF	85.5	85.58	85.48	85.57	81527.0
2009-04-28 19:30:00	SPY	ETF	85.57	85.57	85.51	85.53	124415.0
2009-04-28 04:00:00	QQQ	ETF	33.39	33.39	33.35	33.38	3500.0
2009-04-28 05:00:00	QQQ	ETF	33.43	33.43	33.43	33.43	100.0
2009-04-28 06:00:00	QQQ	ETF	33.39	33.39	33.39	33.39	100.0
2009-04-28 06:30:00	QQQ	ETF	33.39	33.39	33.33	33.37	1700.0
2009-04-28 07:00:00	QQQ	ETF	33.38	33.4	33.34	33.36	31600.0
2009-04-28 07:30:00	QQQ	ETF	33.35	33.41	33.33	33.4	18318.0
2009-04-28 08:00:00	QQQ	ETF	33.41	33.45	33.37	33.4	475569.0
2009-04-28 08:30:00	QQQ	ETF	33.4	33.57	33.35	33.5	1368991.0
2009-04-28 09:00:00	QQQ	ETF	33.51	33.54	33.43	33.51	473388.0
2009-04-28 09:30:00	QQQ	ETF	33.51	33.61	33.36	33.61	12553279.0
2009-04-28 10:00:00	QQQ	ETF	33.61	33.83	33.6	33.8	11840890.0
2009-04-28 10:30:00	QQQ	ETF	33.8	33.91	33.76	33.8101	6397889.0
2009-04-28 11:00:00	QQQ	ETF	33.81	33.9	33.71	33.74	4188386.0
2009-04-28 11:30:00	QQQ	ETF	33.75	33.78	33.66	33.7	5000202.0
2009-04-28 12:00:00	QQQ	ETF	33.71	33.87	33.71	33.81	4966841.0
2009-04-28 12:30:00	QQQ	ETF	33.81	33.86	33.76	33.8	2780297.0
2009-04-28 13:00:00	QQQ	ETF	33.8	33.85	33.62	33.6401	4840942.0
2009-04-28 13:30:00	QQQ	ETF	33.64	33.77	33.52	33.54	7638318.0

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

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