PREVIEW / etf_30min / 2009-09-25

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-09-25.parquet
  size:    228 KB
  rows:    7,573

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-09-25 04:30:00	SPY	ETF	105.09	105.1	105.09	105.1	590.0
2009-09-25 05:30:00	SPY	ETF	105.09	105.09	105.09	105.09	2000.0
2009-09-25 06:00:00	SPY	ETF	105.24	105.34	105.24	105.27	6500.0
2009-09-25 06:30:00	SPY	ETF	105.24	105.24	105.16	105.16	30100.0
2009-09-25 07:00:00	SPY	ETF	105.13	105.27	105.1	105.15	149577.0
2009-09-25 07:30:00	SPY	ETF	105.13	105.31	105.1	105.24	139462.0
2009-09-25 08:00:00	SPY	ETF	105.23	105.25	105.03	105.17	781803.0
2009-09-25 08:30:00	SPY	ETF	105.08	105.16	104.43	104.65	3565492.0
2009-09-25 09:00:00	SPY	ETF	104.65	104.84	104.6	104.78	1346802.0
2009-09-25 09:30:00	SPY	ETF	104.78	105.28	104.55	105.01	24249885.0
2009-09-25 10:00:00	SPY	ETF	105.01	105.36	104.69	105.12	17554209.0
2009-09-25 10:30:00	SPY	ETF	105.12	105.21	104.77	104.89	14817861.0
2009-09-25 11:00:00	SPY	ETF	104.88	105.05	104.65	104.87	14620907.0
2009-09-25 11:30:00	SPY	ETF	104.86	104.93	104.52	104.6	9086626.0
2009-09-25 12:00:00	SPY	ETF	104.6	104.69	104.14	104.27	17175227.0
2009-09-25 12:30:00	SPY	ETF	104.27	104.34	104.18	104.23	8017728.0
2009-09-25 13:00:00	SPY	ETF	104.24	104.41	104.09	104.38	13283056.0
2009-09-25 13:30:00	SPY	ETF	104.38	104.72	104.3	104.67	12793488.0
2009-09-25 14:00:00	SPY	ETF	104.67	104.8333	104.59	104.61	10732335.0
2009-09-25 14:30:00	SPY	ETF	104.61	104.93	104.54	104.899	8011146.0
2009-09-25 15:00:00	SPY	ETF	104.89	104.91	104.64	104.7801	6638170.0
2009-09-25 15:30:00	SPY	ETF	104.78	104.82	104.36	104.47	22189682.0
2009-09-25 16:00:00	SPY	ETF	104.48	105.0717	104.17	104.5	6930357.0
2009-09-25 16:30:00	SPY	ETF	104.5	104.57	104.45	104.47	315388.0
2009-09-25 17:00:00	SPY	ETF	104.46	104.48	104.43	104.48	78945.0
2009-09-25 17:30:00	SPY	ETF	104.48	104.5	104.48	104.5	8500.0
2009-09-25 18:00:00	SPY	ETF	104.5	104.52	104.44	104.47	20740.0
2009-09-25 18:30:00	SPY	ETF	104.47	104.5	104.43	104.49	9880.0
2009-09-25 19:00:00	SPY	ETF	104.48	104.51	104.44	104.51	8184.0
2009-09-25 19:30:00	SPY	ETF	104.47	104.59	104.44	104.57	9083.0
2009-09-25 04:00:00	QQQ	ETF	41.86	41.9	41.86	41.9	5100.0
2009-09-25 04:30:00	QQQ	ETF	41.93	41.93	41.93	41.93	100.0
2009-09-25 05:00:00	QQQ	ETF	41.91	41.91	41.91	41.91	100.0
2009-09-25 05:30:00	QQQ	ETF	41.86	41.86	41.86	41.86	5500.0
2009-09-25 06:00:00	QQQ	ETF	41.95	41.95	41.91	41.91	900.0
2009-09-25 06:30:00	QQQ	ETF	41.87	41.87	41.86	41.86	5200.0
2009-09-25 07:00:00	QQQ	ETF	41.84	41.92	41.84	41.86	27200.0
2009-09-25 07:30:00	QQQ	ETF	41.86	41.94	41.86	41.9	51100.0
2009-09-25 08:00:00	QQQ	ETF	41.91	41.92	41.83	41.89	194946.0
2009-09-25 08:30:00	QQQ	ETF	41.89	41.89	41.65	41.78	1299266.0
2009-09-25 09:00:00	QQQ	ETF	41.79	41.79	41.76	41.77	405316.0
2009-09-25 09:30:00	QQQ	ETF	41.77	42.09	41.75	41.96	17739723.0
2009-09-25 10:00:00	QQQ	ETF	41.96	42.06	41.8	41.9516	13947585.0
2009-09-25 10:30:00	QQQ	ETF	41.95	42.0	41.8	41.87	9087010.0
2009-09-25 11:00:00	QQQ	ETF	41.87	41.93	41.8	41.88	6454943.0
2009-09-25 11:30:00	QQQ	ETF	41.88	41.89	41.75	41.78	4826314.0
2009-09-25 12:00:00	QQQ	ETF	41.762	41.78	41.6	41.682	8146512.0
2009-09-25 12:30:00	QQQ	ETF	41.69	41.7194	41.64	41.6601	2796673.0
2009-09-25 13:00:00	QQQ	ETF	41.67	41.7	41.58	41.7	3840450.0
2009-09-25 13:30:00	QQQ	ETF	41.69	41.85	41.668	41.84	2992614.0

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

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