PREVIEW / etf_30min / 2009-03-10

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-03-10.parquet
  size:    212 KB
  rows:    7,161

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-10 04:00:00	SPY	ETF	68.95	69.24	68.95	69.24	700.0
2009-03-10 04:30:00	SPY	ETF	69.19	69.5	69.19	69.42	6210.0
2009-03-10 05:00:00	SPY	ETF	69.22	69.22	69.21	69.21	6000.0
2009-03-10 05:30:00	SPY	ETF	69.32	69.45	69.32	69.42	2300.0
2009-03-10 06:00:00	SPY	ETF	69.24	69.69	69.24	69.63	26849.0
2009-03-10 06:30:00	SPY	ETF	69.65	69.69	69.48	69.48	85281.0
2009-03-10 07:00:00	SPY	ETF	69.49	69.59	69.3	69.33	727875.0
2009-03-10 07:30:00	SPY	ETF	69.32	69.5	69.26	69.44	561678.0
2009-03-10 08:00:00	SPY	ETF	69.44	69.64	68.75	69.49	1770294.0
2009-03-10 08:30:00	SPY	ETF	69.49	69.61	68.88	69.32	2829990.0
2009-03-10 09:00:00	SPY	ETF	69.31	69.58	69.2	69.52	4510996.0
2009-03-10 09:30:00	SPY	ETF	69.51	70.79	69.37	70.41	49866442.0
2009-03-10 10:00:00	SPY	ETF	70.41	71.3	70.4	70.92	40614644.0
2009-03-10 10:30:00	SPY	ETF	70.91	71.31	70.78	71.05	25601079.0
2009-03-10 11:00:00	SPY	ETF	71.05	71.39	70.81	71.33	19700080.0
2009-03-10 11:30:00	SPY	ETF	71.32	71.84	71.11	71.82	24245769.0
2009-03-10 12:00:00	SPY	ETF	71.83	72.08	71.67	71.89	27464750.0
2009-03-10 12:30:00	SPY	ETF	71.89	71.96	71.57	71.59	14124131.0
2009-03-10 13:00:00	SPY	ETF	71.59	71.8	71.5	71.59	15504307.0
2009-03-10 13:30:00	SPY	ETF	71.59	72.14	71.55	71.66	23525045.0
2009-03-10 14:00:00	SPY	ETF	71.6599	71.83	71.35	71.62	26158096.0
2009-03-10 14:30:00	SPY	ETF	71.62	72.04	71.23	71.83	27150087.0
2009-03-10 15:00:00	SPY	ETF	71.83	72.23	71.55	72.11	30847069.0
2009-03-10 15:30:00	SPY	ETF	72.1	72.37	71.78	72.23	44977514.0
2009-03-10 16:00:00	SPY	ETF	72.22	72.67	71.1	72.18	12088989.0
2009-03-10 16:30:00	SPY	ETF	72.18	72.65	72.02	72.23	8332258.0
2009-03-10 17:00:00	SPY	ETF	72.23	72.34	72.2	72.25	255104.0
2009-03-10 17:30:00	SPY	ETF	72.3	72.38	72.24	72.27	163748.0
2009-03-10 18:00:00	SPY	ETF	72.25	72.28	72.2	72.28	72986.0
2009-03-10 18:30:00	SPY	ETF	72.25	72.35	72.24	72.31	63639.0
2009-03-10 19:00:00	SPY	ETF	72.31	72.34	72.27	72.27	52996.0
2009-03-10 19:30:00	SPY	ETF	72.29	72.32	72.19	72.32	129914.0
2009-03-10 04:00:00	QQQ	ETF	26.06	26.16	26.06	26.12	2600.0
2009-03-10 04:30:00	QQQ	ETF	26.16	26.16	26.16	26.16	250.0
2009-03-10 05:00:00	QQQ	ETF	26.16	26.16	26.1	26.1	400.0
2009-03-10 06:00:00	QQQ	ETF	26.21	26.23	26.21	26.21	1900.0
2009-03-10 06:30:00	QQQ	ETF	26.25	26.27	26.22	26.25	144508.0
2009-03-10 07:00:00	QQQ	ETF	26.25	26.26	26.19	26.2	241341.0
2009-03-10 07:30:00	QQQ	ETF	26.15	26.19	26.15	26.17	59000.0
2009-03-10 08:00:00	QQQ	ETF	26.16	26.27	26.15	26.2	1210402.0
2009-03-10 08:30:00	QQQ	ETF	26.2	26.23	26.13	26.15	842243.0
2009-03-10 09:00:00	QQQ	ETF	26.15	26.29	26.14	26.27	1513823.0
2009-03-10 09:30:00	QQQ	ETF	26.26	26.74	26.16	26.52	26276131.0
2009-03-10 10:00:00	QQQ	ETF	26.52	26.95	26.52	26.86	18128469.0
2009-03-10 10:30:00	QQQ	ETF	26.86	27.0	26.75	26.89	10683433.0
2009-03-10 11:00:00	QQQ	ETF	26.89	26.95	26.7601	26.9201	10664964.0
2009-03-10 11:30:00	QQQ	ETF	26.93	27.14	26.88	27.14	7835585.0
2009-03-10 12:00:00	QQQ	ETF	27.13	27.24	27.1	27.18	9180263.0
2009-03-10 12:30:00	QQQ	ETF	27.18	27.22	27.09	27.11	4734342.0
2009-03-10 13:00:00	QQQ	ETF	27.1121	27.22	27.098	27.15	5783685.0

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

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