PREVIEW / etf_30min / 2008-02-19

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-02-19.parquet
  size:    154 KB
  rows:    5,592

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
2008-02-19 05:30:00	SPY	ETF	136.01	136.02	136.01	136.02	8500.0
2008-02-19 06:00:00	SPY	ETF	136.02	136.19	135.89	135.95	11100.0
2008-02-19 06:30:00	SPY	ETF	135.9	136.44	135.88	136.33	260800.0
2008-02-19 07:00:00	SPY	ETF	136.32	136.42	136.1	136.25	381200.0
2008-02-19 07:30:00	SPY	ETF	136.3	136.62	136.25	136.49	753800.0
2008-02-19 08:00:00	SPY	ETF	136.51	136.99	136.28	136.89	3267500.0
2008-02-19 08:30:00	SPY	ETF	136.87	136.97	134.7	136.67	2046200.0
2008-02-19 09:00:00	SPY	ETF	136.67	136.77	135.85	136.7	1098400.0
2008-02-19 09:30:00	SPY	ETF	136.69	136.89	136.2	136.22	17295856.0
2008-02-19 10:00:00	SPY	ETF	136.22	136.55	136.09	136.2	9761649.0
2008-02-19 10:30:00	SPY	ETF	136.2	136.26	135.76	135.98	10247671.0
2008-02-19 11:00:00	SPY	ETF	135.98	136.1	135.45	135.61	8756515.0
2008-02-19 11:30:00	SPY	ETF	135.62	135.99	135.58	135.96	4940544.0
2008-02-19 12:00:00	SPY	ETF	135.97	136.22	135.82	136.18	5952320.0
2008-02-19 12:30:00	SPY	ETF	136.17	136.17	135.73	135.748	5399485.0
2008-02-19 13:00:00	SPY	ETF	135.75	136.47	135.75	136.35	10270370.0
2008-02-19 13:30:00	SPY	ETF	136.36	136.38	135.97	136.03	5724334.0
2008-02-19 14:00:00	SPY	ETF	136.03	136.32	135.86	136.0	6769351.0
2008-02-19 14:30:00	SPY	ETF	136.002	136.01	134.93	134.96	13443415.0
2008-02-19 15:00:00	SPY	ETF	134.96	136.45	134.65	134.85	15398218.0
2008-02-19 15:30:00	SPY	ETF	134.84	135.35	134.61	135.04	16671459.0
2008-02-19 16:00:00	SPY	ETF	135.02	135.68	135.0	135.6	2336000.0
2008-02-19 16:30:00	SPY	ETF	135.61	135.63	135.39	135.4	148800.0
2008-02-19 17:00:00	SPY	ETF	135.4	135.46	135.38	135.39	110800.0
2008-02-19 17:30:00	SPY	ETF	135.41	135.45	135.31	135.34	42500.0
2008-02-19 18:00:00	SPY	ETF	135.34	135.36	135.27	135.33	42800.0
2008-02-19 18:30:00	SPY	ETF	135.33	135.38	135.28	135.38	12000.0
2008-02-19 19:00:00	SPY	ETF	135.37	135.38	135.3	135.3	4400.0
2008-02-19 19:30:00	SPY	ETF	135.31	135.34	135.2	135.24	16800.0
2008-02-19 04:00:00	QQQ	ETF	44.23	44.25	44.23	44.25	1800.0
2008-02-19 05:00:00	QQQ	ETF	44.28	44.28	44.28	44.28	200.0
2008-02-19 05:30:00	QQQ	ETF	44.25	44.25	44.24	44.24	1590.0
2008-02-19 06:00:00	QQQ	ETF	44.25	44.36	44.25	44.28	7100.0
2008-02-19 06:30:00	QQQ	ETF	44.37	44.4	44.37	44.4	1400.0
2008-02-19 07:00:00	QQQ	ETF	44.41	44.41	44.29	44.31	188494.0
2008-02-19 07:30:00	QQQ	ETF	44.28	44.46	44.28	44.39	574728.0
2008-02-19 08:00:00	QQQ	ETF	44.39	44.6	44.36	44.5	1869464.0
2008-02-19 08:30:00	QQQ	ETF	44.52	44.56	44.38	44.39	818367.0
2008-02-19 09:00:00	QQQ	ETF	44.38	44.5	44.1	44.39	562602.0
2008-02-19 09:30:00	QQQ	ETF	44.39	44.49	44.19	44.1999	14281481.0
2008-02-19 10:00:00	QQQ	ETF	44.1905	44.28	44.1	44.208	8628527.0
2008-02-19 10:30:00	QQQ	ETF	44.2	44.21	44.04	44.1075	7121995.0
2008-02-19 11:00:00	QQQ	ETF	44.1099	44.14	43.97	44.0115	5255107.0
2008-02-19 11:30:00	QQQ	ETF	44.01	44.13	44.005	44.13	3437588.0
2008-02-19 12:00:00	QQQ	ETF	44.13	44.26	44.0801	44.23	5183126.0
2008-02-19 12:30:00	QQQ	ETF	44.23	44.23	44.03	44.05	5026442.0
2008-02-19 13:00:00	QQQ	ETF	44.05	44.29	44.045	44.2285	4567095.0
2008-02-19 13:30:00	QQQ	ETF	44.22	44.23	43.99	44.02	5581382.0
2008-02-19 14:00:00	QQQ	ETF	44.02	44.04	43.91	43.91	5087332.0
2008-02-19 14:30:00	QQQ	ETF	43.91	43.91	43.42	43.42	12680741.0

> showing 50 of 5,592 rows — these rows as CSV

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