PREVIEW / etf_30min / 2009-03-20

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-03-20.parquet
  size:    207 KB
  rows:    6,741

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-03-20 04:00:00	SPY	ETF	77.85	77.85	77.82	77.82	2400.0
2009-03-20 04:30:00	SPY	ETF	77.85	77.85	77.81	77.81	300.0
2009-03-20 05:00:00	SPY	ETF	77.8	77.8	77.75	77.75	3125.0
2009-03-20 05:30:00	SPY	ETF	77.75	77.81	77.58	77.75	23100.0
2009-03-20 06:00:00	SPY	ETF	77.64	77.74	77.51	77.7	12800.0
2009-03-20 06:30:00	SPY	ETF	77.67	78.12	77.64	78.12	21975.0
2009-03-20 07:00:00	SPY	ETF	78.14	78.41	78.08	78.4	187326.0
2009-03-20 07:30:00	SPY	ETF	78.41	78.65	78.17	78.57	410999.0
2009-03-20 08:00:00	SPY	ETF	78.58	78.67	77.72	78.6	1344755.0
2009-03-20 08:30:00	SPY	ETF	78.63	78.83	78.58	78.73	2075933.0
2009-03-20 09:00:00	SPY	ETF	78.72	78.9	78.56	78.77	3255887.0
2009-03-20 09:30:00	SPY	ETF	78.76	78.901	78.21	78.33	41095373.0
2009-03-20 10:00:00	SPY	ETF	78.33	78.53	77.98	78.51	33870927.0
2009-03-20 10:30:00	SPY	ETF	78.511	78.55	78.16	78.45	16909152.0
2009-03-20 11:00:00	SPY	ETF	78.455	78.91	77.89	78.0	44104860.0
2009-03-20 11:30:00	SPY	ETF	78.0	78.29	77.91	78.1099	22075694.0
2009-03-20 12:00:00	SPY	ETF	78.11	78.37	77.94	78.21	13299108.0
2009-03-20 12:30:00	SPY	ETF	78.2	78.38	77.47	77.64	18239943.0
2009-03-20 13:00:00	SPY	ETF	77.63	78.3	77.19	77.26	14443220.0
2009-03-20 13:30:00	SPY	ETF	77.25	77.42	76.76	76.8	22846852.0
2009-03-20 14:00:00	SPY	ETF	76.8	76.93	76.53	76.89	24539925.0
2009-03-20 14:30:00	SPY	ETF	76.89	77.0	76.53	76.91	22613900.0
2009-03-20 15:00:00	SPY	ETF	76.91	77.38	76.9	77.18	23933738.0
2009-03-20 15:30:00	SPY	ETF	77.17	77.55	76.69	76.71	41118349.0
2009-03-20 16:00:00	SPY	ETF	76.67	78.05	76.62	76.74	9193596.0
2009-03-20 16:30:00	SPY	ETF	76.76	76.99	76.71	76.99	2040133.0
2009-03-20 17:00:00	SPY	ETF	76.99	77.04	76.93	76.96	230018.0
2009-03-20 17:30:00	SPY	ETF	76.99	77.06	76.91	77.0	47854.0
2009-03-20 18:00:00	SPY	ETF	77.0	77.0	76.82	76.82	52425.0
2009-03-20 18:30:00	SPY	ETF	76.82	76.85	76.72	76.82	31210.0
2009-03-20 19:00:00	SPY	ETF	76.85	76.85	76.71	76.77	13071.0
2009-03-20 19:30:00	SPY	ETF	76.74	76.81	76.71	76.75	6979.0
2009-03-20 04:00:00	QQQ	ETF	29.52	29.52	29.52	29.52	100.0
2009-03-20 05:00:00	QQQ	ETF	29.53	29.53	29.52	29.52	200.0
2009-03-20 06:30:00	QQQ	ETF	29.57	29.57	29.57	29.57	100.0
2009-03-20 07:00:00	QQQ	ETF	29.6	29.71	29.56	29.68	162904.0
2009-03-20 07:30:00	QQQ	ETF	29.68	29.71	29.6	29.69	55413.0
2009-03-20 08:00:00	QQQ	ETF	29.68	29.71	29.63	29.68	176428.0
2009-03-20 08:30:00	QQQ	ETF	29.69	29.74	29.65	29.71	278311.0
2009-03-20 09:00:00	QQQ	ETF	29.72	29.74	29.57	29.67	1077647.0
2009-03-20 09:30:00	QQQ	ETF	29.67	30.03	29.66	29.87	22765261.0
2009-03-20 10:00:00	QQQ	ETF	29.87	29.89	29.7	29.88	10335296.0
2009-03-20 10:30:00	QQQ	ETF	29.87	29.89	29.75	29.85	6011802.0
2009-03-20 11:00:00	QQQ	ETF	29.85	29.85	29.56	29.6	8253148.0
2009-03-20 11:30:00	QQQ	ETF	29.61	29.7	29.57	29.6	7091806.0
2009-03-20 12:00:00	QQQ	ETF	29.6	29.66	29.55	29.61	3910851.0
2009-03-20 12:30:00	QQQ	ETF	29.61	29.67	29.29	29.35	8120068.0
2009-03-20 13:00:00	QQQ	ETF	29.35	29.37	29.16	29.2	8502838.0
2009-03-20 13:30:00	QQQ	ETF	29.19	29.6	29.05	29.07	8053592.0
2009-03-20 14:00:00	QQQ	ETF	29.0604	29.16	28.98	29.15	9114104.0

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

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