PREVIEW / etf_30min / 2009-02-12

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-02-12.parquet
  size:    203 KB
  rows:    6,838

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-02-12 04:00:00	SPY	ETF	82.75	82.75	82.75	82.75	200.0
2009-02-12 04:30:00	SPY	ETF	82.82	82.92	82.8	82.8	5300.0
2009-02-12 05:00:00	SPY	ETF	82.74	82.84	82.62	82.65	28750.0
2009-02-12 05:30:00	SPY	ETF	82.62	82.62	82.51	82.6	20585.0
2009-02-12 06:00:00	SPY	ETF	82.5	82.69	82.5	82.63	10666.0
2009-02-12 06:30:00	SPY	ETF	82.8	82.9	82.65	82.75	38100.0
2009-02-12 07:00:00	SPY	ETF	82.72	82.92	82.71	82.91	647838.0
2009-02-12 07:30:00	SPY	ETF	82.85	82.92	82.58	82.6	335860.0
2009-02-12 08:00:00	SPY	ETF	82.85	82.85	82.47	82.65	2751769.0
2009-02-12 08:30:00	SPY	ETF	82.65	83.05	82.65	82.77	3323435.0
2009-02-12 09:00:00	SPY	ETF	82.81	82.81	81.96	82.15	4195083.0
2009-02-12 09:30:00	SPY	ETF	82.17	82.22	81.5	81.64	42786861.0
2009-02-12 10:00:00	SPY	ETF	81.65	82.04	81.3	81.96	36585266.0
2009-02-12 10:30:00	SPY	ETF	81.97	82.37	81.69	82.2101	31549714.0
2009-02-12 11:00:00	SPY	ETF	82.22	82.36	81.68	82.03	27388553.0
2009-02-12 11:30:00	SPY	ETF	82.03	82.69	82.02	82.31	25954631.0
2009-02-12 12:00:00	SPY	ETF	82.32	82.96	82.27	82.87	22106532.0
2009-02-12 12:30:00	SPY	ETF	82.87	82.95	82.49	82.52	12277582.0
2009-02-12 13:00:00	SPY	ETF	82.53	82.61	81.99	82.15	26290956.0
2009-02-12 13:30:00	SPY	ETF	82.15	82.29	81.75	82.19	27511288.0
2009-02-12 14:00:00	SPY	ETF	82.2	82.4	81.81	81.88	21628214.0
2009-02-12 14:30:00	SPY	ETF	81.89	82.03	81.17	81.35	31197282.0
2009-02-12 15:00:00	SPY	ETF	81.35	82.81	81.05	82.8099	49687831.0
2009-02-12 15:30:00	SPY	ETF	82.79	83.82	81.2	83.69	71476214.0
2009-02-12 16:00:00	SPY	ETF	83.66	84.1	81.75	83.92	18282651.0
2009-02-12 16:30:00	SPY	ETF	83.93	83.99	83.91	83.95	2766647.0
2009-02-12 17:00:00	SPY	ETF	83.94	84.04	83.6235	83.93	2334097.0
2009-02-12 17:30:00	SPY	ETF	83.92	83.94	83.8	83.86	142687.0
2009-02-12 18:00:00	SPY	ETF	83.86	84.09	83.86	84.04	198120.0
2009-02-12 18:30:00	SPY	ETF	84.02	84.04	83.78	83.78	154895.0
2009-02-12 19:00:00	SPY	ETF	83.77	83.8	83.69	83.78	51156.0
2009-02-12 19:30:00	SPY	ETF	83.78	83.8	83.7	83.71	32041.0
2009-02-12 04:00:00	QQQ	ETF	29.9	29.9	29.9	29.9	200.0
2009-02-12 04:30:00	QQQ	ETF	29.92	29.92	29.92	29.92	400.0
2009-02-12 06:00:00	QQQ	ETF	29.8	29.8	29.75	29.75	400.0
2009-02-12 06:30:00	QQQ	ETF	29.94	29.94	29.94	29.94	100.0
2009-02-12 07:00:00	QQQ	ETF	29.91	30.04	29.91	29.95	452227.0
2009-02-12 07:30:00	QQQ	ETF	29.98	30.04	29.92	29.92	68072.0
2009-02-12 08:00:00	QQQ	ETF	29.93	29.98	29.85	29.96	484760.0
2009-02-12 08:30:00	QQQ	ETF	29.98	30.1	29.96	30.04	504817.0
2009-02-12 09:00:00	QQQ	ETF	30.04	30.04	29.71	29.83	1073201.0
2009-02-12 09:30:00	QQQ	ETF	29.83	30.03	29.7	29.82	23281038.0
2009-02-12 10:00:00	QQQ	ETF	29.81	30.01	29.64	29.98	14912128.0
2009-02-12 10:30:00	QQQ	ETF	29.99	30.17	29.88	30.07	11484362.0
2009-02-12 11:00:00	QQQ	ETF	30.06	30.15	29.92	30.03	7796241.0
2009-02-12 11:30:00	QQQ	ETF	30.03	30.39	30.01	30.22	15454945.0
2009-02-12 12:00:00	QQQ	ETF	30.22	30.51	30.2	30.45	11111489.0
2009-02-12 12:30:00	QQQ	ETF	30.46	30.48	30.27	30.27	6813830.0
2009-02-12 13:00:00	QQQ	ETF	30.28	30.3	30.01	30.09	12862717.0
2009-02-12 13:30:00	QQQ	ETF	30.1	30.19	29.97	30.17	9253737.0

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

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