PREVIEW / etf_30min / 2009-08-13

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-08-13.parquet
  size:    231 KB
  rows:    7,638

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-08-13 04:00:00	SPY	ETF	101.3	101.4	101.29	101.4	2800.0
2009-08-13 04:30:00	SPY	ETF	101.45	101.59	101.44	101.59	3100.0
2009-08-13 05:00:00	SPY	ETF	101.6	101.63	101.6	101.63	2950.0
2009-08-13 05:30:00	SPY	ETF	101.66	101.66	101.62	101.62	10200.0
2009-08-13 06:00:00	SPY	ETF	101.48	101.55	101.48	101.52	800.0
2009-08-13 06:30:00	SPY	ETF	101.52	101.64	101.52	101.61	26700.0
2009-08-13 07:00:00	SPY	ETF	101.66	101.95	101.62	101.8	275651.0
2009-08-13 07:30:00	SPY	ETF	101.82	101.83	101.65	101.66	592932.0
2009-08-13 08:00:00	SPY	ETF	101.66	101.95	100.85	101.95	1808871.0
2009-08-13 08:30:00	SPY	ETF	101.93	101.94	100.96	101.27	6412170.0
2009-08-13 09:00:00	SPY	ETF	101.28	101.43	101.25	101.26	2333093.0
2009-08-13 09:30:00	SPY	ETF	101.26	101.31	100.26	100.4	26844201.0
2009-08-13 10:00:00	SPY	ETF	100.39	100.93	100.3	100.8399	17085964.0
2009-08-13 10:30:00	SPY	ETF	100.83	101.46	100.8	101.33	15056938.0
2009-08-13 11:00:00	SPY	ETF	101.32	101.43	101.07	101.16	11911760.0
2009-08-13 11:30:00	SPY	ETF	101.16	101.27	100.9901	101.25	6659234.0
2009-08-13 12:00:00	SPY	ETF	101.24	101.31	101.19	101.24	4713650.0
2009-08-13 12:30:00	SPY	ETF	101.2401	101.3701	101.21	101.25	5720572.0
2009-08-13 13:00:00	SPY	ETF	101.25	101.61	101.16	101.17	14044489.0
2009-08-13 13:30:00	SPY	ETF	101.17	101.31	101.0	101.0984	7529486.0
2009-08-13 14:00:00	SPY	ETF	101.09	101.11	100.7	100.96	9952537.0
2009-08-13 14:30:00	SPY	ETF	100.96	101.31	100.94	100.942	5922272.0
2009-08-13 15:00:00	SPY	ETF	100.9499	101.43	100.9499	101.32	9921928.0
2009-08-13 15:30:00	SPY	ETF	101.32	101.58	101.26	101.58	18080012.0
2009-08-13 16:00:00	SPY	ETF	101.6	101.83	100.3	101.75	9112932.0
2009-08-13 16:30:00	SPY	ETF	101.75	101.8	100.8427	101.72	2220883.0
2009-08-13 17:00:00	SPY	ETF	101.73	101.84	101.73	101.8	84330.0
2009-08-13 17:30:00	SPY	ETF	101.77	101.77	101.7	101.75	21325.0
2009-08-13 18:00:00	SPY	ETF	101.73	101.78	101.7	101.74	37997.0
2009-08-13 18:30:00	SPY	ETF	101.75	101.78	101.68	101.7	10773.0
2009-08-13 19:00:00	SPY	ETF	101.71	101.72	101.68	101.72	23644.0
2009-08-13 19:30:00	SPY	ETF	101.7	101.73	101.67	101.71	28385.0
2009-08-13 04:00:00	QQQ	ETF	40.04	40.07	40.04	40.07	600.0
2009-08-13 04:30:00	QQQ	ETF	40.15	40.15	40.15	40.15	100.0
2009-08-13 05:00:00	QQQ	ETF	40.14	40.15	40.14	40.15	1800.0
2009-08-13 05:30:00	QQQ	ETF	40.2	40.22	40.2	40.22	10600.0
2009-08-13 06:00:00	QQQ	ETF	40.15	40.15	40.15	40.15	15100.0
2009-08-13 06:30:00	QQQ	ETF	40.17	40.17	40.16	40.16	6401.0
2009-08-13 07:00:00	QQQ	ETF	40.16	40.32	40.16	40.27	186364.0
2009-08-13 07:30:00	QQQ	ETF	40.27	40.29	40.25	40.25	346806.0
2009-08-13 08:00:00	QQQ	ETF	40.26	40.35	40.23	40.34	2066072.0
2009-08-13 08:30:00	QQQ	ETF	40.34	40.34	40.0	40.15	2904867.0
2009-08-13 09:00:00	QQQ	ETF	40.15	40.21	40.09	40.11	1191939.0
2009-08-13 09:30:00	QQQ	ETF	40.1	40.11	39.64	39.75	17933868.0
2009-08-13 10:00:00	QQQ	ETF	39.75	39.97	39.71	39.9122	13443998.0
2009-08-13 10:30:00	QQQ	ETF	39.91	40.16	39.9099	40.11	5999841.0
2009-08-13 11:00:00	QQQ	ETF	40.11	40.14	39.93	39.97	11412281.0
2009-08-13 11:30:00	QQQ	ETF	39.98	40.03	39.93	40.03	2262220.0
2009-08-13 12:00:00	QQQ	ETF	40.02	40.05	39.97	40.02	2702134.0
2009-08-13 12:30:00	QQQ	ETF	40.01	40.09	40.01	40.04	1852902.0

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

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