PREVIEW / etf_30min / 2009-06-25

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-06-25.parquet
  size:    219 KB
  rows:    7,117

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-06-25 04:00:00	SPY	ETF	91.06	91.08	90.95	90.97	6745.0
2009-06-25 04:30:00	SPY	ETF	90.93	90.93	90.73	90.73	400.0
2009-06-25 05:00:00	SPY	ETF	90.7	90.83	90.43	90.49	1600.0
2009-06-25 05:30:00	SPY	ETF	90.53	90.53	90.33	90.35	866.0
2009-06-25 06:00:00	SPY	ETF	90.36	90.39	90.1	90.1	11200.0
2009-06-25 06:30:00	SPY	ETF	90.1	90.25	90.1	90.2	105450.0
2009-06-25 07:00:00	SPY	ETF	90.22	90.43	90.16	90.42	194856.0
2009-06-25 07:30:00	SPY	ETF	90.43	90.56	90.33	90.33	178152.0
2009-06-25 08:00:00	SPY	ETF	90.32	90.35	90.1	90.17	785601.0
2009-06-25 08:30:00	SPY	ETF	90.16	90.16	89.53	89.62	3633221.0
2009-06-25 09:00:00	SPY	ETF	89.62	89.75	89.61	89.67	976600.0
2009-06-25 09:30:00	SPY	ETF	89.67	90.5	89.57	90.41	29228518.0
2009-06-25 10:00:00	SPY	ETF	90.41	90.99	90.41	90.865	30183315.0
2009-06-25 10:30:00	SPY	ETF	90.87	90.9	90.55	90.65	15364683.0
2009-06-25 11:00:00	SPY	ETF	90.65	91.11	90.57	91.1	9704249.0
2009-06-25 11:30:00	SPY	ETF	91.1	91.76	91.045	91.72	22115946.0
2009-06-25 12:00:00	SPY	ETF	91.72	91.84	91.66	91.81	16144873.0
2009-06-25 12:30:00	SPY	ETF	91.81	91.89	91.58	91.6	11099888.0
2009-06-25 13:00:00	SPY	ETF	91.6	92.17	91.56	92.03	18119065.0
2009-06-25 13:30:00	SPY	ETF	92.02	92.09	91.82	91.93	6935439.0
2009-06-25 14:00:00	SPY	ETF	91.93	91.96	91.46	91.695	17229765.0
2009-06-25 14:30:00	SPY	ETF	91.71	91.81	91.49	91.665	12316229.0
2009-06-25 15:00:00	SPY	ETF	91.67	91.95	91.59	91.865	22081221.0
2009-06-25 15:30:00	SPY	ETF	91.87	92.06	91.37	92.03	32307386.0
2009-06-25 16:00:00	SPY	ETF	92.04	92.17	90.0837	92.1	15528880.0
2009-06-25 16:30:00	SPY	ETF	92.09	92.12	92.0	92.03	279133.0
2009-06-25 17:00:00	SPY	ETF	92.05	92.05	91.98	92.0	207559.0
2009-06-25 17:30:00	SPY	ETF	92.04	92.07	92.0	92.0	321404.0
2009-06-25 18:00:00	SPY	ETF	92.0	92.04	91.98	92.02	47126.0
2009-06-25 18:30:00	SPY	ETF	92.02	92.02	91.95	91.95	17330.0
2009-06-25 19:00:00	SPY	ETF	91.97	91.99	91.97	91.99	5211.0
2009-06-25 19:30:00	SPY	ETF	91.99	92.04	91.93	91.95	26943.0
2009-06-25 04:00:00	QQQ	ETF	35.87	35.87	35.87	35.87	960.0
2009-06-25 04:30:00	QQQ	ETF	35.84	35.84	35.84	35.84	100.0
2009-06-25 05:00:00	QQQ	ETF	35.8	35.8	35.8	35.8	760.0
2009-06-25 06:00:00	QQQ	ETF	35.62	35.62	35.56	35.56	1400.0
2009-06-25 06:30:00	QQQ	ETF	35.6	35.6	35.57	35.57	762.0
2009-06-25 07:00:00	QQQ	ETF	35.6	35.66	35.6	35.66	27962.0
2009-06-25 07:30:00	QQQ	ETF	35.73	35.74	35.66	35.66	49165.0
2009-06-25 08:00:00	QQQ	ETF	35.66	35.66	35.51	35.54	355930.0
2009-06-25 08:30:00	QQQ	ETF	35.53	35.53	35.38	35.43	757649.0
2009-06-25 09:00:00	QQQ	ETF	35.43	35.47	35.38	35.39	416529.0
2009-06-25 09:30:00	QQQ	ETF	35.38	35.91	35.28	35.83	18383233.0
2009-06-25 10:00:00	QQQ	ETF	35.84	36.13	35.83	36.04	14591132.0
2009-06-25 10:30:00	QQQ	ETF	36.04	36.09	35.6	35.98	7535622.0
2009-06-25 11:00:00	QQQ	ETF	35.99	36.1301	35.8	36.13	4059169.0
2009-06-25 11:30:00	QQQ	ETF	36.13	36.3	35.85	36.29	7354459.0
2009-06-25 12:00:00	QQQ	ETF	36.3	36.31	36.2	36.245	5582979.0
2009-06-25 12:30:00	QQQ	ETF	36.26	36.28	36.16	36.18	3129209.0
2009-06-25 13:00:00	QQQ	ETF	36.18	36.36	36.15	36.3	5454077.0

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

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